-- @owner: lvlintao666
-- @date: 2022/04/12
-- @testpoint: 对指定default serial.nextval的int类型的数组的主键约束，部分测试点合理报错

--step1:建表;expect:成功
drop sequence if exists serial cascade ;
create sequence serial start 101 cache 20;
drop table if exists t_ustore_datatype_array_0027;
create table t_ustore_datatype_array_0027 (c1_int int default serial.nextval primary key,c2_varchar varchar(8000)[] null,c3_bigint bigint,c4_int int[]) with (storage_type=ustore);

--step2:插入数据;expect:部分测试点合理报错
insert into t_ustore_datatype_array_0027 values(serial.nextval,null,83678569,array[1234,0.00000001,2147483647]);
insert into t_ustore_datatype_array_0027 values(null,array[' ','gdff',null,'12'],83678569,array[null,0.00000001,2147483647]);
select * from t_ustore_datatype_array_0027;
analyze t_ustore_datatype_array_0027 ;

--step3:环境清理;expect:成功
drop table t_ustore_datatype_array_0027;
drop sequence serial cascade ;